Tabela ContractServiceRestriction

Definicja tabeli ContractServiceRestriction

Name

ContractServiceRestriction

Code

ContractServiceRestriction

Comment

 


Lista kolumn tabeli ContractServiceRestriction

Name

Code

AgeFrom

AgeFrom

AgeTo

AgeTo

ContractServiceRestrictionID

ContractServiceRestrictionID

POZSchoolTypeID

POZSchoolTypeID

POZPersonnelTypeID

POZPersonnelTypeID

DPS

DPS

ICD9Required

ICD9Required

NFZConfirmation

NFZConfirmation

OneDayContractService

OneDayContractService

Sex

Sex

ToStatisticReport

ToStatisticReport

TreatmentSchemaRequired

TreatmentSchemaRequired

PerformingLocation

PerformingLocation

AgeFromCalculationMethodID

AgeFromCalculationMethodID

AgeToCalculationMethodID

AgeToCalculationMethodID

HospitalizationMode

HospitalizationMode

BasisOfExecution

BasisOfExecution

SupplyKind

SupplyKind


Kolumna AgeFrom tabeli ContractServiceRestriction

Definicja kolumny AgeFrom tabeli ContractServiceRestriction

Name

AgeFrom

Code

AgeFrom

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AgeTo tabeli ContractServiceRestriction

Definicja kolumny AgeTo tabeli ContractServiceRestriction

Name

AgeTo

Code

AgeTo

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractServiceRestrictionID tabeli ContractServiceRestriction

Definicja kolumny ContractServiceRestrictionID tabeli ContractServiceRestriction

Name

ContractServiceRestrictionID

Code

ContractServiceRestrictionID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna POZSchoolTypeID tabeli ContractServiceRestriction

Definicja kolumny POZSchoolTypeID tabeli ContractServiceRestriction

Name

POZSchoolTypeID

Code

POZSchoolTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna POZPersonnelTypeID tabeli ContractServiceRestriction

Definicja kolumny POZPersonnelTypeID tabeli ContractServiceRestriction

Name

POZPersonnelTypeID

Code

POZPersonnelTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DPS tabeli ContractServiceRestriction

Definicja kolumny DPS tabeli ContractServiceRestriction

Name

DPS

Code

DPS

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Kolumna ICD9Required tabeli ContractServiceRestriction

Definicja kolumny ICD9Required tabeli ContractServiceRestriction

Name

ICD9Required

Code

ICD9Required

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna NFZConfirmation tabeli ContractServiceRestriction

Definicja kolumny NFZConfirmation tabeli ContractServiceRestriction

Name

NFZConfirmation

Code

NFZConfirmation

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Kolumna OneDayContractService tabeli ContractServiceRestriction

Definicja kolumny OneDayContractService tabeli ContractServiceRestriction

Name

OneDayContractService

Code

OneDayContractService

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Sex tabeli ContractServiceRestriction

Definicja kolumny Sex tabeli ContractServiceRestriction

Name

Sex

Code

Sex

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Kolumna ToStatisticReport tabeli ContractServiceRestriction

Definicja kolumny ToStatisticReport tabeli ContractServiceRestriction

Name

ToStatisticReport

Code

ToStatisticReport

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna TreatmentSchemaRequired tabeli ContractServiceRestriction

Definicja kolumny TreatmentSchemaRequired tabeli ContractServiceRestriction

Name

TreatmentSchemaRequired

Code

TreatmentSchemaRequired

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna PerformingLocation tabeli ContractServiceRestriction

Definicja kolumny PerformingLocation tabeli ContractServiceRestriction

Name

PerformingLocation

Code

PerformingLocation

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna AgeFromCalculationMethodID tabeli ContractServiceRestriction

Definicja kolumny AgeFromCalculationMethodID tabeli ContractServiceRestriction

Name

AgeFromCalculationMethodID

Code

AgeFromCalculationMethodID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AgeToCalculationMethodID tabeli ContractServiceRestriction

Definicja kolumny AgeToCalculationMethodID tabeli ContractServiceRestriction

Name

AgeToCalculationMethodID

Code

AgeToCalculationMethodID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna HospitalizationMode tabeli ContractServiceRestriction

Definicja kolumny HospitalizationMode tabeli ContractServiceRestriction

Name

HospitalizationMode

Code

HospitalizationMode

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna BasisOfExecution tabeli ContractServiceRestriction

Definicja kolumny BasisOfExecution tabeli ContractServiceRestriction

Name

BasisOfExecution

Code

BasisOfExecution

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Kolumna SupplyKind tabeli ContractServiceRestriction

Definicja kolumny SupplyKind tabeli ContractServiceRestriction

Name

SupplyKind

Code

SupplyKind

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Lista kluczy tabeli ContractServiceRestriction

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ContractServiceRestriction

Definicja klucza Identifier_1 tabeli ContractServiceRestriction

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment